/**
 * @author r
 * @date 2020/12/11 17:12
 */
package com.rjj.wlqq.tool.excel.ry_excel;

/*
* ruoyi中excel导出
* */
/*

public class SysUser
{

    */
/** 用户ID *//*

    @Excel(name = "用户序号", cellType = ColumnType.NUMERIC, prompt = "用户编号")
    private Long userId;

    */
/** 部门ID *//*

    @Excel(name = "部门编号", type = Type.IMPORT)
    private Long deptId;

    */
/** 用户性别 *//*

    @Excel(name = "用户性别", readConverterExp = "0=男,1=女,2=未知")
    private String sex;

    */
/** 帐号状态（0正常 1停用） *//*

    private String status;

    */
/** 最后登录IP *//*

    @Excel(name = "最后登录IP", type = Type.EXPORT)
    private String loginIp;

    */
/** 最后登录时间 *//*

    @Excel(name = "最后登录时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss", type = Type.EXPORT)
    private Date loginDate;

    */
/** 部门对象 *//*

    @Excels({
            @Excel(name = "部门名称", targetAttr = "deptName", type = Type.EXPORT),
            @Excel(name = "部门负责人", targetAttr = "leader", type = Type.EXPORT)
    })
    private SysDept dept;
}
*/


/**
 导入
 ExcelUtil<SysUser> util = new ExcelUtil<SysUser>(SysUser.class);
 List<SysUser> userList = util.importExcel(file.getInputStream());
 */

/**
 * 导出
 List<SysUser> list = userService.selectUserList(user);
 ExcelUtil<SysUser> util = new ExcelUtil<SysUser>(SysUser.class);
 util.exportExcel(response, list, "用户数据");

 * */